﻿CREATE TABLE [dbo].[OrderDetails]
(
	[Id] INT NOT NULL PRIMARY KEY IDENTITY, 
    [GoodsId] INT NULL, 
    [GoodsQuantity] INT NULL, 
    [GoodsAmount] DECIMAL(5, 2) NULL, 
    [OriginalPrice] DECIMAL(5, 2) NULL, 
    [TradePrice] DECIMAL(5, 2) NULL, 
    [CreateDate] DATETIME NULL
)

GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'商品ID',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'OrderDetails',
    @level2type = N'COLUMN',
    @level2name = N'GoodsId'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'商品总金额',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'OrderDetails',
    @level2type = N'COLUMN',
    @level2name = N'GoodsAmount'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'商品原始单价=购买时单价',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'OrderDetails',
    @level2type = N'COLUMN',
    @level2name = N'OriginalPrice'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'最终成交的单价',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'OrderDetails',
    @level2type = N'COLUMN',
    @level2name = N'TradePrice'